Executive Summary 5


Troubles that occurred during the project:
  1. Column Names had spaces in them causing the package to fail. I had to Change the column name to be formatted into Carmel casing.
  2. Package failing because String Null could not be loaded into a Numeric Null. While loading the Fact table. I later discovered this and fixed it. I am currently loading the fact table using Merge Statement like see below.